EMT Practice Test

1. Question Content...

---

Question1: How can you create a packaged data source?

Question2: You need to create a calculation that returns a customer name followed by a comma, a space, and then the customer's age (for example: John Doe, 32).
What should you include in the calculation?

Question3: What is the minimum amount of RAM recommended for any production use of Tableau Server?

Question4: How would you calculate GDP per capita in Tableau?

Question5: What are two use cases for creating hierarchies from the Data pane? Choose two.

Question6: True or False: It is not possible to blend axes for multiple measures into a single axis

Question7: Which chart type uses automatically generated sizes that cannot be resized by using the Marks card?

Question8: Which chart type uses automatically generated sizes that cannot be resized by using the Marks card?

Question9: Which of the following are True for Measure Names?

Question10: What does the following icon do in Tableau?
Larger image

Question11: By default, measures placed in a view are aggregated. The type of aggregation applied ______________

Question12: Which of the following are valid ways to make the font more readable in Tableau?

Question13: Which of the following charts types always includes bars sorted in descending order?

Question14: Larger image

What is this entire view referred to as in Tableau?

Question15: How does Tableau know at which level to aggregate values?

Question16: Download the Dataset from:
https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?

Question17: Which statement accurately describes aliases?

Question18: Which of the following are valid ways to add Totals to a view?

Question19: Which of the following are the options to export the data used to build the view / visualisations?

Question20: You can _______________ your data to combine two or more tables by appending values (rows) from one table to another

Question21: Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible?

Question22: Which of the following is not a Trend Line Model?

Question23: True or False: A reference line cannot be added from the Analytics Pane

Question24: Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?
Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

Question25: In order to avoid any confusions, what should you do after creating a Dual-axis chart?

Question26: Which of the following is a benefit of using a Tableau Data Source (.tds)?

Question27: A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data.

Question28: A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.

Question29: Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?

Question30: Which mark type is used in a highlight table?

Question31: Which two types of aggregations can be applied to string fields? Choose two.

Question32: Is it possible to add both a Dashboard and a Worksheet at the same time to a Story Point in Tableau?

Question33: You want to update the font of an entire workbook.
What should you use to configure the default fonts?

Question34: What are two ways to share a dashboard as an image file? Choose two.

Question35: You need to invert the color intensity of a quantitative range. Which option should you use?

Question36: You want to provide additional information when hovering over a field in the Data pane as shown in the following exhibit.

What should you configure for the field?

Question37: ______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

Question38: How can you add color to marks in the view in Tableau?

Question39: In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.

Question40: Which of the following are stored in a .tds file? Choose 3.

Question41: What are three geographic roles that you can assign to a field? Choose three.

Question42: Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections?

Question43:
You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace as shown above. What is the main thing that you do here?

Question44: If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can
__________________ the view.

Question45: Which of these is NOT a type of Quick Filter available in Tableau?

Question46: ______________ refers to the level of detail for a piece of data, wherever you are looking.

Question47: How can you change the Default Aggregation for a measure in Tableau?

Question48: In which situation should you save a workbook as a PDF document?

Question49: Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf.
Which of the following would create a stacked bar chart?

Question50: Which of the following fields would be best used as Dimensions?

Question51: Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser?

Question52: When using a Blend, what is the color of tick-mark on the primary and secondary data sources respectively?

Question53: Which of the following are valid ways to export a dashboard with multiple visualisations as an image?

Question54: Which of the following are benefits of using Data Extracts in Tableau?

Question55: You have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases. Which of the following would BEST satisfy this requirement?

Question56: Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

Question57: You have a bar chart that has a dimension on the Columns shelf and a measure on the Rows shelf.
How can you make a stacked bar chart?

Question58: When creating a histogram in Tableau, to what does bin size refer?

Question59: For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in.

Question60: Which statement accurately describes an extract when the Physical Tables option is selected?

Question61: When creating an extract, what are three options for specifying how much data to extract? Choose three.

Question62: _________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

Question63: We can join a maximum of ______ tables in Tableau

Question64: When field names in the Union do not match, then:

Question65: For which of the following charts, does the Size option on the Marks card not work?

Question66: Which of the following chart type makes use of 'binned' data?

Question67: Which of the following is an example of a Date Part?

Question68: When using a data source that has relationships, how can you add a join between two or more tables?

Question69: What will the following function return?
LEFT("Tableau", 3)

Question70: Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?

Question71: In an extract, what are three differences between a full refresh versus an incremental refresh? Choose three.

Question72: Which of the following are interactive elements that can be added to a dashboard for users?

Question73: With the Marks card drop-down menu set to Automatic, a line chart will be created whenever you place what on the Rows shelf and the Columns shelf?

Question74: You create a crosstab that shows a list of 100 hotel chains alongside their average nightly cost. You also create two groups showing, respectively, the top 10 and bottom 10 hotel chains by cost, with subtotals.
What should you do to improve the crosstab and compare the two groups to all the remaining hotel chains?

Question75: Which of the following are compelling reasons to use a Stacked Bar Chart?

Question76: True or False: Tableau can create worksheet-specific filters

Question77: Which statement accurately describes a join?

Question78: You want to add Custom shapes to your visualisation. Where can you add these new shapes?

Question79: Which chart type uses automatically generated sizes that cannot be resized by using the Marks card?

Question80: You have the following string value: Sales Data.
Which calculated field produces an output of Sales?

Question81: You can create _______________ for members in a dimension so that their labels appear differently in the view.

Question82: Which of the following are FALSE about Joins?

Question83: Which of the following options best describe measures?

Question84: Which of the following 2 columns CANNOT be deleted in Tableau?

Question85: True or False: To concatenate fields, they must be of same data type

Question86: Which of the following points are True about Viz Animations?

Question87: Using the atheletes table:
i) Create a sheet with a crosstab showing the Average weight for each sport (Sheet 1) ii) Create a sheet with a Map showing the Total number of gold medals per Country. Use size as a Mark.
(Sheet 2)
Now, Create a Dashboard containing both these sheets, and Use Sheet 2 as a Filter for Sheet 1. What was the average weight for Badminton in Russia?
(Ignore any nulls / unknowns)

Question88: When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.

Question89: Larger image

What is this view referred to as in Tableau?

Question90: As a general best practice, how many categories can a pie chart display effectively?

Question91: True or False: It is possible to add a field to more than one hierarchy

Question92: _____________ charts are typically used to represent accumulated totals over time and are the conventional way to display stacked lines.

Question93: In which of the following scenarios would having a live connection be more beneficial than using an extract?

Question94: You need to display the complete list of potential data connections when you connect to a server. What action should you perform?

Question95: You create a visualization by first adding a measure to rows. Next, you add a dimension wilh 11 members to columns.
Assuming that all the dimensions have a non-zero value, how many marks are in the view before and after the dimension is added?

Question96: True or False: You get different filtering options for categorical and quantitative data

Question97: Which statement accurately describes creating a group by selecting headers in a view?

Question98: Dimensions containing ____________ and ____________ values cannot be continuous.

Question99: ________________ can only create header. _______________ will create header and axis both.

Question100: Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

Question101: At a minimum, what do you need to create a simple scatter plot?

Question102: You can use the __________________ in Tableau to clean / organise your data.

Question103: Which aggregation is available without requiring a table calculation or calculated field?

Question104: _____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields.

Question105: Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through
2014, respectively?

Question106: _____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.

Question107: Data blending simulates a traditional _________________ Join

Question108: Which of the following is a good reason for using a bullet graph?

Question109: Which of the following is a discrete date part?

Question110: Which two analytics options are available for a scatter plot view? Choose two.

Question111: Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

Question112: How can you MANUALLY assign geographic roles to a dimension from the data pane?

Question113: When creating a date filter in Tableau, to what does Anchor refer?

Question114: If you use a percent difference Quick Table Calculation, what value will be the first data value?

Question115: Yes or No: The number of marks will increase when you increase the number of Dimensions in a view

Question116: Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?

Question117: When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette.

Question118: Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a
____________ and a ____________.

Question119: Which of the following are valid ways to italicize Tooltip content in Tableau?

Question120: True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity

Question121: How can you set the default properties of a field to Currency?

Question122: Given a map, which of the following fields can be placed in Size,Shape,Detail,Color

Question123: A dual axis chart is useful for comparing two measures that___________.

Question124: By default, what does Tableau do when you connect to a data source?

Question125: A field that shows average home values for the United States in 2016 is most likely :

Question126: Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

Question127: What are two use cases for a story? Choose two.

Question128: Which Sub-Category had the least Profit in the Office Supplies category?

Question129: Using the Time-series table, create a cross tab showing the Sales for each Item Number-ID, broken down by Assortments, then add Grand totals to the view. Which Item Number ID made the maximum sales across all assortments?

Question130: Relationships are represented by __________________ and operate at the ____________________.

Question131: Which type of date filter can you use to choose a range of dates based on TODAY ()?

Question132: If you are working with a huge dataset, which of the following are strong reasons to use a context filter?

Question133: You may create a context filter to:

Question134: What should you use to create headers in a visualization?

Question135: What does the box in a box plot represent?

Question136: Which two filter modes can you use with continuous filters? Choose two.

Question137: To customize links based on the data in your dashboard, you can automatically enter field values as
_______________ in URLs